/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : localhost:3306
 Source Schema         : sc_gateway

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 10/07/2020 14:12:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for gateway_route
-- ----------------------------
DROP TABLE IF EXISTS `gateway_route`;
CREATE TABLE `gateway_route` (
  `id` varchar(20) NOT NULL COMMENT 'id',
  `route_id` varchar(100) NOT NULL COMMENT '路由id',
  `uri` varchar(100) NOT NULL COMMENT 'uri路径',
  `predicates` text NOT NULL COMMENT '判定器',
  `filters` text COMMENT '过滤器',
  `orders` int(11) DEFAULT NULL COMMENT '排序',
  `description` varchar(500) DEFAULT NULL COMMENT '描述',
  `del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记  -1：已删除  0：正常',
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_by` varchar(100) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(100) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`),
  KEY `ux_gateway_routes_uri` (`uri`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='网关路由表';

-- ----------------------------
-- Records of gateway_route
-- ----------------------------
BEGIN;
INSERT INTO `gateway_route` VALUES ('101', 'authorization-server', 'lb://authorization-server:8000', '[{\"name\":\"Path\",\"args\":{\"pattern\":\"/authorization-server/**\"}}]', '[{\"name\":\"StripPrefix\",\"args\":{\"parts\":\"1\"}}]', 100, '授权认证服务网关注册', 0, '2019-11-20 15:31:15', '2019-11-20 15:31:15', 'system', 'system');
INSERT INTO `gateway_route` VALUES ('102', 'authentication-server', 'lb://authentication-server:8001', '[{\"name\":\"Path\",\"args\":{\"pattern\":\"/authentication-server/**\"}}]', '[{\"name\":\"StripPrefix\",\"args\":{\"parts\":\"1\"}}]', 100, '签权服务网关注册', 0, '2019-11-20 15:31:15', '2019-11-20 15:31:15', 'system', 'system');
INSERT INTO `gateway_route` VALUES ('103', 'platform-web', 'lb://platform-web:8010', '[{\"args\":{\"pattern\":\"/platform-web/**\"},\"name\":\"Path\"}]', '[{\"args\":{\"parts\":\"1\"},\"name\":\"StripPrefix\"}]', 0, '这是一个转发XX服务的路由1', 0, '2020-05-27 13:50:13', '2020-05-27 13:50:13', 'system', NULL);
INSERT INTO `gateway_route` VALUES ('104', 'gateway-admin', 'lb://gateway-admin:8445', '[{\"name\":\"Path\",\"args\":{\"pattern\":\"/gateway-admin/**\"}}]', '[{\"name\":\"StripPrefix\",\"args\":{\"parts\":\"1\"}}]', 100, '网关管理相关接口', 0, '2019-11-20 15:31:15', '2019-11-20 15:31:15', 'system', 'system');
INSERT INTO `gateway_route` VALUES ('1272756874437984258', 'web-tes32t', 'lb://platform-web:8010', '[{\"args\":{\"pattern\":\"/platform-web111312/**\"},\"name\":\"Path\"}]', '[{\"args\":{\"parts\":\"1\"},\"name\":\"StripPrefix\"}]', 0, '这是一个转发XX服务的路由1', 0, NULL, NULL, NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
